package com.example.exam.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface RoleIntefaceMapper {

    @Select("SELECT  r.name FROM inteface as i JOIN  role_inteface as ri ON i.id=ri.inter "+
                 "JOIN  role as r ON  r.id=ri.role WHERE  i.name=#{name} ")
    List<String> selectRoleAndInteByInteName(String name);
}
